package com.mingloucct.payment_ws.dao;

import com.mingloucct.payment_ws.entity.Neishen;
import com.mingloucct.payment_ws.entity.ShenHeInfo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import org.springframework.web.multipart.MultipartFile;

import java.util.List;

@Repository
public interface INeishenDao {
    List<Neishen> readNeishen(@Param("quary") String quary);
    List<Neishen> readWaishen(@Param("quary") String quary);
    List<Neishen> readFangkuan(@Param("quary") String quary);
    void updateByID(@Param("customID") String customID,
                    @Param("date") String date,
                    @Param("CustomName") String CustomName,
                    @Param("Province") String Province,
                    @Param("City") String City,
                    @Param("Address") String Address,
                    @Param("PostNum") String PostNum
    );
    void updateShenheByID(@Param("CustomID") String customID,
                    @Param("CarPrice") String CarPrice,
                    @Param("Prepay") String Prepay,
                    @Param("Dai_kuan_jin_e") String Dai_kuan_jin_e,
                    @Param("Zong_he_li_lv") String Zong_he_li_lv,
                    @Param("Dai_kuan_nian_shu") String Dai_kuan_nian_shu,
                    @Param("Yue_gong") String Yue_gong,
                    @Param("Dai_kuan_lei_xing") String Dai_kuan_lei_xing,
                    @Param("Marriage") String Marriage
    );
    void deleteByID(@Param("customID") String customID);
    void changeByID(@Param("customID") String customID,@Param("amount") String amount);
    String upLoadFile(@Param("file") MultipartFile upload,@Param("CustomID")String CustomID,@Param("Type")int Type);
    void uploadToDB(@Param("CustomID") String CustomID,@Param("url") String url,@Param("type") String Type,@Param("filename") String filename);
    ShenHeInfo selectShenHeInfo(@Param("CustomID") String CustomID);
    void changeStatus(@Param("customID")String customID);
}
